Overview

Dataset statistics

Number of variables14
Number of observations346213
Missing cells54115
Missing cells (%)1.1%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory37.0 MiB
Average record size in memory112.0 B

Variable types

Categorical3
DateTime1
Numeric9
Text1

Alerts

VERSIE has constant value ""Constant
DATUM_BESTAND has constant value ""Constant
PEILDATUM has constant value ""Constant
GEMIDDELDE_VERKOOPPRIJS has 54115 (15.6%) missing valuesMissing
AANTAL_SUBTRAJECT_PER_ZPD is highly skewed (γ1 = 21.44392654)Skewed

Reproduction

Analysis started2023-12-05 15:42:30.642729
Analysis finished2023-12-05 15:42:47.668550
Duration17.03 seconds
Software versionydata-profiling v0.0.dev0
Download configurationconfig.json

Variables

VERSIE
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size2.6 MiB
1.0
346213 

Length

Max length3
Median length3
Mean length3
Min length3

Characters and Unicode

Total characters1038639
Distinct characters3
Distinct categories2 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row1.0
2nd row1.0
3rd row1.0
4th row1.0
5th row1.0

Common Values

ValueCountFrequency (%)
1.0 346213
100.0%

Length

2023-12-05T15:42:47.759820image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-05T15:42:47.895288image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
ValueCountFrequency (%)
1.0 346213
100.0%

Most occurring characters

ValueCountFrequency (%)
1 346213
33.3%
. 346213
33.3%
0 346213
33.3%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 692426
66.7%
Other Punctuation 346213
33.3%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
1 346213
50.0%
0 346213
50.0%
Other Punctuation
ValueCountFrequency (%)
. 346213
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1038639
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
1 346213
33.3%
. 346213
33.3%
0 346213
33.3%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1038639
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1 346213
33.3%
. 346213
33.3%
0 346213
33.3%

DATUM_BESTAND
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size2.6 MiB
2023-11-20
346213 

Length

Max length10
Median length10
Mean length10
Min length10

Characters and Unicode

Total characters3462130
Distinct characters5
Distinct categories2 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-11-20
2nd row2023-11-20
3rd row2023-11-20
4th row2023-11-20
5th row2023-11-20

Common Values

ValueCountFrequency (%)
2023-11-20 346213
100.0%

Length

2023-12-05T15:42:48.035565image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-05T15:42:48.168020image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-11-20 346213
100.0%

Most occurring characters

ValueCountFrequency (%)
2 1038639
30.0%
0 692426
20.0%
- 692426
20.0%
1 692426
20.0%
3 346213
 
10.0%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 2769704
80.0%
Dash Punctuation 692426
 
20.0%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
2 1038639
37.5%
0 692426
25.0%
1 692426
25.0%
3 346213
 
12.5%
Dash Punctuation
ValueCountFrequency (%)
- 692426
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 3462130
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
2 1038639
30.0%
0 692426
20.0%
- 692426
20.0%
1 692426
20.0%
3 346213
 
10.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 3462130
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
2 1038639
30.0%
0 692426
20.0%
- 692426
20.0%
1 692426
20.0%
3 346213
 
10.0%

PEILDATUM
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size2.6 MiB
2023-11-01
346213 

Length

Max length10
Median length10
Mean length10
Min length10

Characters and Unicode

Total characters3462130
Distinct characters5
Distinct categories2 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-11-01
2nd row2023-11-01
3rd row2023-11-01
4th row2023-11-01
5th row2023-11-01

Common Values

ValueCountFrequency (%)
2023-11-01 346213
100.0%

Length

2023-12-05T15:42:48.307868image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-05T15:42:48.587336image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-11-01 346213
100.0%

Most occurring characters

ValueCountFrequency (%)
1 1038639
30.0%
2 692426
20.0%
0 692426
20.0%
- 692426
20.0%
3 346213
 
10.0%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 2769704
80.0%
Dash Punctuation 692426
 
20.0%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
1 1038639
37.5%
2 692426
25.0%
0 692426
25.0%
3 346213
 
12.5%
Dash Punctuation
ValueCountFrequency (%)
- 692426
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 3462130
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
1 1038639
30.0%
2 692426
20.0%
0 692426
20.0%
- 692426
20.0%
3 346213
 
10.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 3462130
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1 1038639
30.0%
2 692426
20.0%
0 692426
20.0%
- 692426
20.0%
3 346213
 
10.0%

JAAR
Date

Distinct12
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size2.6 MiB
Minimum2012-01-01 00:00:00
Maximum2023-01-01 00:00:00
2023-12-05T15:42:48.702015image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2023-12-05T15:42:48.851761image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
Histogram with fixed size bins (bins=12)
Distinct28
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean451.02967
Minimum301
Maximum8418
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.6 MiB
2023-12-05T15:42:49.019011image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/

Quantile statistics

Minimum301
5-th percentile302
Q1305
median313
Q3322
95-th percentile361
Maximum8418
Range8117
Interquartile range (IQR)17

Descriptive statistics

Standard deviation1038.9564
Coefficient of variation (CV)2.3035212
Kurtosis54.718454
Mean451.02967
Median Absolute Deviation (MAD)8
Skewness7.5263612
Sum1.5615234 × 108
Variance1079430.5
MonotonicityNot monotonic
2023-12-05T15:42:49.209174image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
Histogram with fixed size bins (bins=28)
ValueCountFrequency (%)
305 48557
14.0%
313 44934
13.0%
303 39831
11.5%
330 27329
 
7.9%
316 23541
 
6.8%
308 18724
 
5.4%
306 14541
 
4.2%
324 14202
 
4.1%
301 13845
 
4.0%
304 11282
 
3.3%
Other values (18) 89427
25.8%
ValueCountFrequency (%)
301 13845
 
4.0%
302 7624
 
2.2%
303 39831
11.5%
304 11282
 
3.3%
305 48557
14.0%
306 14541
 
4.2%
307 6072
 
1.8%
308 18724
 
5.4%
310 3779
 
1.1%
313 44934
13.0%
ValueCountFrequency (%)
8418 4680
 
1.4%
8416 1100
 
0.3%
1900 229
 
0.1%
390 954
 
0.3%
389 3622
 
1.0%
362 4447
 
1.3%
361 2517
 
0.7%
335 3495
 
1.0%
330 27329
7.9%
329 905
 
0.3%
Distinct1902
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size2.6 MiB
2023-12-05T15:42:49.611316image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/

Length

Max length4
Median length3
Mean length3.3528204
Min length2

Characters and Unicode

Total characters1160790
Distinct characters25
Distinct categories2 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique10 ?
Unique (%)< 0.1%

Sample

1st rowF21
2nd rowM16
3rd rowB15
4th rowK24
5th rowG23
ValueCountFrequency (%)
101 1481
 
0.4%
402 1422
 
0.4%
403 1396
 
0.4%
301 1392
 
0.4%
201 1321
 
0.4%
203 1290
 
0.4%
401 1166
 
0.3%
404 1152
 
0.3%
409 1124
 
0.3%
802 1122
 
0.3%
Other values (1892) 333347
96.3%
2023-12-05T15:42:50.234535image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1 221967
19.1%
0 213288
18.4%
2 153832
13.3%
3 125578
10.8%
5 89585
7.7%
9 83562
 
7.2%
4 82225
 
7.1%
7 68396
 
5.9%
6 60608
 
5.2%
8 50020
 
4.3%
Other values (15) 11729
 
1.0%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 1149061
99.0%
Uppercase Letter 11729
 
1.0%

Most frequent character per category

Uppercase Letter
ValueCountFrequency (%)
G 2187
18.6%
M 1972
16.8%
B 1424
12.1%
Z 1014
8.6%
E 984
8.4%
D 769
 
6.6%
A 761
 
6.5%
F 729
 
6.2%
C 386
 
3.3%
K 379
 
3.2%
Other values (5) 1124
9.6%
Decimal Number
ValueCountFrequency (%)
1 221967
19.3%
0 213288
18.6%
2 153832
13.4%
3 125578
10.9%
5 89585
7.8%
9 83562
 
7.3%
4 82225
 
7.2%
7 68396
 
6.0%
6 60608
 
5.3%
8 50020
 
4.4%

Most occurring scripts

ValueCountFrequency (%)
Common 1149061
99.0%
Latin 11729
 
1.0%

Most frequent character per script

Latin
ValueCountFrequency (%)
G 2187
18.6%
M 1972
16.8%
B 1424
12.1%
Z 1014
8.6%
E 984
8.4%
D 769
 
6.6%
A 761
 
6.5%
F 729
 
6.2%
C 386
 
3.3%
K 379
 
3.2%
Other values (5) 1124
9.6%
Common
ValueCountFrequency (%)
1 221967
19.3%
0 213288
18.6%
2 153832
13.4%
3 125578
10.9%
5 89585
7.8%
9 83562
 
7.3%
4 82225
 
7.2%
7 68396
 
6.0%
6 60608
 
5.3%
8 50020
 
4.4%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1160790
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1 221967
19.1%
0 213288
18.4%
2 153832
13.3%
3 125578
10.8%
5 89585
7.7%
9 83562
 
7.2%
4 82225
 
7.1%
7 68396
 
5.9%
6 60608
 
5.2%
8 50020
 
4.3%
Other values (15) 11729
 
1.0%

ZORGPRODUCT_CD
Real number (ℝ)

Distinct6196
Distinct (%)1.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean4.4118692 × 108
Minimum10501002
Maximum9.9841808 × 108
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.6 MiB
2023-12-05T15:42:50.463225image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/

Quantile statistics

Minimum10501002
5-th percentile28999040
Q199799067
median1.4959903 × 108
Q39.90004 × 108
95-th percentile9.9051605 × 108
Maximum9.9841808 × 108
Range9.8791708 × 108
Interquartile range (IQR)8.9020494 × 108

Descriptive statistics

Standard deviation4.2906031 × 108
Coefficient of variation (CV)0.97251366
Kurtosis-1.7391839
Mean4.4118692 × 108
Median Absolute Deviation (MAD)1.1960003 × 108
Skewness0.46571714
Sum1.5274465 × 1014
Variance1.8409275 × 1017
MonotonicityNot monotonic
2023-12-05T15:42:50.677902image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
990004009 2534
 
0.7%
990004007 2488
 
0.7%
990003004 2394
 
0.7%
990004006 2021
 
0.6%
990356076 1850
 
0.5%
990356073 1718
 
0.5%
131999228 1696
 
0.5%
131999164 1670
 
0.5%
990003007 1549
 
0.4%
131999194 1524
 
0.4%
Other values (6186) 326769
94.4%
ValueCountFrequency (%)
10501002 9
< 0.1%
10501003 12
< 0.1%
10501004 12
< 0.1%
10501005 12
< 0.1%
10501007 3
 
< 0.1%
10501008 12
< 0.1%
10501010 12
< 0.1%
10501011 3
 
< 0.1%
11101002 11
< 0.1%
11101003 12
< 0.1%
ValueCountFrequency (%)
998418081 176
0.1%
998418080 160
< 0.1%
998418079 40
 
< 0.1%
998418077 9
 
< 0.1%
998418076 9
 
< 0.1%
998418075 7
 
< 0.1%
998418074 240
0.1%
998418073 241
0.1%
998418072 9
 
< 0.1%
998418071 9
 
< 0.1%

AANTAL_PAT_PER_ZPD
Real number (ℝ)

Distinct10449
Distinct (%)3.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean510.89698
Minimum1
Maximum165184
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.6 MiB
2023-12-05T15:42:50.889337image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1
Q13
median13
Q3102
95-th percentile1725
Maximum165184
Range165183
Interquartile range (IQR)99

Descriptive statistics

Standard deviation3178.1465
Coefficient of variation (CV)6.220719
Kurtosis416.34993
Mean510.89698
Median Absolute Deviation (MAD)12
Skewness16.880538
Sum1.7687918 × 108
Variance10100615
MonotonicityNot monotonic
2023-12-05T15:42:51.094857image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 57494
 
16.6%
2 28055
 
8.1%
3 18371
 
5.3%
4 13374
 
3.9%
5 10511
 
3.0%
6 8842
 
2.6%
7 7418
 
2.1%
8 6180
 
1.8%
9 5682
 
1.6%
10 5087
 
1.5%
Other values (10439) 185199
53.5%
ValueCountFrequency (%)
1 57494
16.6%
2 28055
8.1%
3 18371
 
5.3%
4 13374
 
3.9%
5 10511
 
3.0%
6 8842
 
2.6%
7 7418
 
2.1%
8 6180
 
1.8%
9 5682
 
1.6%
10 5087
 
1.5%
ValueCountFrequency (%)
165184 1
< 0.1%
162461 1
< 0.1%
158301 1
< 0.1%
155869 1
< 0.1%
154539 1
< 0.1%
154258 1
< 0.1%
144714 1
< 0.1%
118396 1
< 0.1%
115935 1
< 0.1%
113248 1
< 0.1%

AANTAL_SUBTRAJECT_PER_ZPD
Real number (ℝ)

SKEWED 

Distinct11205
Distinct (%)3.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean605.51161
Minimum1
Maximum240002
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.6 MiB
2023-12-05T15:42:51.270981image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1
Q13
median14
Q3111
95-th percentile1972
Maximum240002
Range240001
Interquartile range (IQR)108

Descriptive statistics

Standard deviation4102.4335
Coefficient of variation (CV)6.7751525
Kurtosis729.15346
Mean605.51161
Median Absolute Deviation (MAD)13
Skewness21.443927
Sum2.0963599 × 108
Variance16829961
MonotonicityNot monotonic
2023-12-05T15:42:51.426862image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 55381
 
16.0%
2 27571
 
8.0%
3 18184
 
5.3%
4 13180
 
3.8%
5 10421
 
3.0%
6 8810
 
2.5%
7 7344
 
2.1%
8 6136
 
1.8%
9 5608
 
1.6%
10 5081
 
1.5%
Other values (11195) 188497
54.4%
ValueCountFrequency (%)
1 55381
16.0%
2 27571
8.0%
3 18184
 
5.3%
4 13180
 
3.8%
5 10421
 
3.0%
6 8810
 
2.5%
7 7344
 
2.1%
8 6136
 
1.8%
9 5608
 
1.6%
10 5081
 
1.5%
ValueCountFrequency (%)
240002 1
< 0.1%
232423 1
< 0.1%
231954 1
< 0.1%
230939 1
< 0.1%
227936 1
< 0.1%
227409 1
< 0.1%
226233 1
< 0.1%
223891 1
< 0.1%
218673 1
< 0.1%
215131 1
< 0.1%

AANTAL_PAT_PER_DIAG
Real number (ℝ)

Distinct9408
Distinct (%)2.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean7661.0515
Minimum1
Maximum230662
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.6 MiB
2023-12-05T15:42:51.571656image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile40
Q1395
median1693
Q36243
95-th percentile36749
Maximum230662
Range230661
Interquartile range (IQR)5848

Descriptive statistics

Standard deviation17896.73
Coefficient of variation (CV)2.336067
Kurtosis35.029884
Mean7661.0515
Median Absolute Deviation (MAD)1548
Skewness5.120952
Sum2.6523556 × 109
Variance3.2029293 × 108
MonotonicityNot monotonic
2023-12-05T15:42:51.718765image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
21 613
 
0.2%
17 523
 
0.2%
8 522
 
0.2%
26 509
 
0.1%
25 508
 
0.1%
9 502
 
0.1%
12 501
 
0.1%
19 491
 
0.1%
14 489
 
0.1%
23 477
 
0.1%
Other values (9398) 341078
98.5%
ValueCountFrequency (%)
1 402
0.1%
2 464
0.1%
3 476
0.1%
4 450
0.1%
5 477
0.1%
6 447
0.1%
7 458
0.1%
8 522
0.2%
9 502
0.1%
10 411
0.1%
ValueCountFrequency (%)
230662 23
< 0.1%
229208 20
< 0.1%
227999 23
< 0.1%
218495 24
< 0.1%
214507 17
< 0.1%
213515 25
< 0.1%
211579 17
< 0.1%
210415 19
< 0.1%
205337 17
< 0.1%
200600 16
< 0.1%
Distinct10496
Distinct (%)3.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean11107.437
Minimum1
Maximum370139
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.6 MiB
2023-12-05T15:42:51.893567image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile51
Q1523
median2368
Q39066
95-th percentile52146
Maximum370139
Range370138
Interquartile range (IQR)8543

Descriptive statistics

Standard deviation26862.034
Coefficient of variation (CV)2.4183828
Kurtosis38.366335
Mean11107.437
Median Absolute Deviation (MAD)2178
Skewness5.3546399
Sum3.845539 × 109
Variance7.2156889 × 108
MonotonicityNot monotonic
2023-12-05T15:42:52.069309image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
17 442
 
0.1%
25 436
 
0.1%
23 424
 
0.1%
3 410
 
0.1%
4 397
 
0.1%
20 397
 
0.1%
6 396
 
0.1%
10 391
 
0.1%
13 387
 
0.1%
34 387
 
0.1%
Other values (10486) 342146
98.8%
ValueCountFrequency (%)
1 317
0.1%
2 337
0.1%
3 410
0.1%
4 397
0.1%
5 368
0.1%
6 396
0.1%
7 364
0.1%
8 355
0.1%
9 293
0.1%
10 391
0.1%
ValueCountFrequency (%)
370139 23
< 0.1%
365382 23
< 0.1%
350959 20
< 0.1%
348482 25
< 0.1%
344610 24
< 0.1%
341651 19
< 0.1%
323753 20
< 0.1%
315771 17
< 0.1%
310754 17
< 0.1%
298627 17
< 0.1%

AANTAL_PAT_PER_SPC
Real number (ℝ)

Distinct325
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean665955.03
Minimum1610
Maximum1487632
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.6 MiB
2023-12-05T15:42:52.231338image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/

Quantile statistics

Minimum1610
5-th percentile41749
Q1260836
median757846
Q31026293
95-th percentile1332313
Maximum1487632
Range1486022
Interquartile range (IQR)765457

Descriptive statistics

Standard deviation418497.13
Coefficient of variation (CV)0.6284165
Kurtosis-1.1773654
Mean665955.03
Median Absolute Deviation (MAD)319233
Skewness0.011544625
Sum2.3056229 × 1011
Variance1.7513984 × 1011
MonotonicityNot monotonic
2023-12-05T15:42:52.389757image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
880928 5102
 
1.5%
874088 4354
 
1.3%
843978 4347
 
1.3%
894305 4333
 
1.3%
880465 4273
 
1.2%
897698 4212
 
1.2%
765015 4089
 
1.2%
803555 4028
 
1.2%
781731 3993
 
1.2%
1080721 3890
 
1.1%
Other values (315) 303592
87.7%
ValueCountFrequency (%)
1610 130
 
< 0.1%
1829 138
 
< 0.1%
1920 131
 
< 0.1%
2495 173
< 0.1%
2553 190
0.1%
2862 102
 
< 0.1%
4140 168
< 0.1%
5156 68
 
< 0.1%
6117 331
0.1%
6805 380
0.1%
ValueCountFrequency (%)
1487632 2975
0.9%
1450390 3048
0.9%
1421702 3564
1.0%
1344256 3543
1.0%
1340565 3441
1.0%
1332313 3545
1.0%
1316350 3463
1.0%
1282933 3576
1.0%
1278266 3370
1.0%
1267046 3350
1.0%

AANTAL_SUBTRAJECT_PER_SPC
Real number (ℝ)

Distinct325
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1080927.3
Minimum1861
Maximum2664173
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.6 MiB
2023-12-05T15:42:52.547437image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/

Quantile statistics

Minimum1861
5-th percentile46341
Q1378547
median1087900
Q31808514
95-th percentile2548166
Maximum2664173
Range2662312
Interquartile range (IQR)1429967

Descriptive statistics

Standard deviation753404.17
Coefficient of variation (CV)0.69699799
Kurtosis-0.829534
Mean1080927.3
Median Absolute Deviation (MAD)716868
Skewness0.3690758
Sum3.7423109 × 1011
Variance5.6761784 × 1011
MonotonicityNot monotonic
2023-12-05T15:42:52.706383image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1211797 5102
 
1.5%
1281482 4354
 
1.3%
1216253 4347
 
1.3%
1315564 4333
 
1.3%
1300429 4273
 
1.2%
1341821 4212
 
1.2%
1155933 4089
 
1.2%
1205563 4028
 
1.2%
1157648 3993
 
1.2%
2548166 3890
 
1.1%
Other values (315) 303592
87.7%
ValueCountFrequency (%)
1861 130
 
< 0.1%
2097 138
 
< 0.1%
2195 131
 
< 0.1%
2816 173
< 0.1%
3052 102
 
< 0.1%
3321 190
0.1%
4946 168
< 0.1%
5427 68
 
< 0.1%
6300 331
0.1%
7384 380
0.1%
ValueCountFrequency (%)
2664173 3866
1.1%
2662911 3793
1.1%
2618563 3789
1.1%
2593432 3843
1.1%
2548166 3890
1.1%
2514582 3889
1.1%
2479950 3851
1.1%
2178503 3757
1.1%
2062152 3811
1.1%
2052147 1168
 
0.3%

GEMIDDELDE_VERKOOPPRIJS
Real number (ℝ)

MISSING 

Distinct3640
Distinct (%)1.2%
Missing54115
Missing (%)15.6%
Infinite0
Infinite (%)0.0%
Mean3594.7539
Minimum70
Maximum287220
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.6 MiB
2023-12-05T15:42:52.854933image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/

Quantile statistics

Minimum70
5-th percentile140
Q1480
median1250
Q34175
95-th percentile13710
Maximum287220
Range287150
Interquartile range (IQR)3695

Descriptive statistics

Standard deviation6523.3583
Coefficient of variation (CV)1.8146884
Kurtosis138.49976
Mean3594.7539
Median Absolute Deviation (MAD)1020
Skewness6.9966081
Sum1.0500204 × 109
Variance42554203
MonotonicityNot monotonic
2023-12-05T15:42:53.143435image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
160 2100
 
0.6%
105 1977
 
0.6%
110 1791
 
0.5%
180 1614
 
0.5%
300 1607
 
0.5%
185 1580
 
0.5%
140 1515
 
0.4%
175 1474
 
0.4%
125 1388
 
0.4%
165 1384
 
0.4%
Other values (3630) 275668
79.6%
(Missing) 54115
 
15.6%
ValueCountFrequency (%)
70 226
 
0.1%
75 75
 
< 0.1%
80 362
 
0.1%
85 919
0.3%
90 663
 
0.2%
95 727
 
0.2%
100 1019
0.3%
105 1977
0.6%
110 1791
0.5%
115 1156
0.3%
ValueCountFrequency (%)
287220 8
< 0.1%
148910 3
 
< 0.1%
142835 4
< 0.1%
122155 4
< 0.1%
116765 3
 
< 0.1%
109725 7
< 0.1%
108570 7
< 0.1%
107655 4
< 0.1%
101270 8
< 0.1%
99590 5
< 0.1%

Interactions

2023-12-05T15:42:45.021298image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2023-12-05T15:42:33.130660image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2023-12-05T15:42:34.712346image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2023-12-05T15:42:36.149151image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2023-12-05T15:42:37.623988image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2023-12-05T15:42:39.045643image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2023-12-05T15:42:40.462972image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2023-12-05T15:42:42.101655image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2023-12-05T15:42:43.578510image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2023-12-05T15:42:45.193650image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2023-12-05T15:42:33.308339image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2023-12-05T15:42:34.882093image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2023-12-05T15:42:36.320980image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2023-12-05T15:42:37.793194image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2023-12-05T15:42:39.211355image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2023-12-05T15:42:40.640865image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2023-12-05T15:42:42.279246image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2023-12-05T15:42:43.748383image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2023-12-05T15:42:45.354065image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2023-12-05T15:42:33.470472image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2023-12-05T15:42:35.033331image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2023-12-05T15:42:36.474572image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2023-12-05T15:42:37.949947image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2023-12-05T15:42:39.361970image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2023-12-05T15:42:40.941227image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2023-12-05T15:42:42.437751image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2023-12-05T15:42:43.902844image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2023-12-05T15:42:45.516029image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2023-12-05T15:42:33.717666image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2023-12-05T15:42:35.189911image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2023-12-05T15:42:36.632702image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2023-12-05T15:42:38.105383image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2023-12-05T15:42:39.516879image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2023-12-05T15:42:41.107478image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2023-12-05T15:42:42.604233image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2023-12-05T15:42:44.064258image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2023-12-05T15:42:45.673998image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2023-12-05T15:42:33.881548image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2023-12-05T15:42:35.343784image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2023-12-05T15:42:36.788658image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2023-12-05T15:42:38.258809image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2023-12-05T15:42:39.668373image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2023-12-05T15:42:41.267855image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2023-12-05T15:42:42.763214image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2023-12-05T15:42:44.219710image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2023-12-05T15:42:45.823267image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2023-12-05T15:42:34.035722image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2023-12-05T15:42:35.491548image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2023-12-05T15:42:36.964471image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2023-12-05T15:42:38.406362image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2023-12-05T15:42:39.817094image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2023-12-05T15:42:41.422060image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2023-12-05T15:42:42.915213image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2023-12-05T15:42:44.369057image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2023-12-05T15:42:45.991130image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2023-12-05T15:42:34.206796image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2023-12-05T15:42:35.660100image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2023-12-05T15:42:37.130294image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2023-12-05T15:42:38.570392image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2023-12-05T15:42:39.982029image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2023-12-05T15:42:41.592332image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2023-12-05T15:42:43.082772image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2023-12-05T15:42:44.533263image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2023-12-05T15:42:46.162206image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2023-12-05T15:42:34.380381image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2023-12-05T15:42:35.828162image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2023-12-05T15:42:37.299681image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2023-12-05T15:42:38.732872image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2023-12-05T15:42:40.150237image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2023-12-05T15:42:41.769267image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2023-12-05T15:42:43.251296image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2023-12-05T15:42:44.701511image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2023-12-05T15:42:46.323204image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2023-12-05T15:42:34.543767image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2023-12-05T15:42:35.990514image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2023-12-05T15:42:37.461249image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2023-12-05T15:42:38.889291image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2023-12-05T15:42:40.305175image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2023-12-05T15:42:41.936374image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2023-12-05T15:42:43.413291image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2023-12-05T15:42:44.858994image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/

Missing values

2023-12-05T15:42:46.574540image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-05T15:42:47.068511image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

Sample

VERSIEDATUM_BESTANDPEILDATUMJAARBEHANDELEND_SPECIALISME_CDTYPERENDE_DIAGNOSE_CDZORGPRODUCT_CDAANTAL_PAT_PER_ZPDAANTAL_SUBTRAJECT_PER_ZPDAANTAL_PAT_PER_DIAGAANTAL_SUBTRAJECT_PER_DIAGAANTAL_PAT_PER_SPCAANTAL_SUBTRAJECT_PER_SPCGEMIDDELDE_VERKOOPPRIJS
01.02023-11-202023-11-012021-01-01307F2197280402236044439253718280971632811962591510.0
11.02023-11-202023-11-012021-01-01307M1620108156231125829108177163281196259835.0
21.02023-11-202023-11-012021-01-01307B1515989900422247247716328119625910860.0
31.02023-11-202023-11-012021-01-01307K2415989902010541101145715747163281196259330.0
41.02023-11-202023-11-012021-01-01307G23149399026380403579937517171632811962592110.0
51.02023-11-202023-11-012021-01-01307Z28159999033752767414748237163281196259605.0
61.02023-11-202023-11-012021-01-01307F119728040242237991549897163281196259670.0
71.02023-11-202023-11-012021-01-01307M16201081813723855829108177163281196259635.0
81.02023-11-202023-11-012021-01-01307G251499990456658583903247163281196259NaN
91.02023-11-202023-11-012021-01-01307K25598990082219207163281196259NaN
VERSIEDATUM_BESTANDPEILDATUMJAARBEHANDELEND_SPECIALISME_CDTYPERENDE_DIAGNOSE_CDZORGPRODUCT_CDAANTAL_PAT_PER_ZPDAANTAL_SUBTRAJECT_PER_ZPDAANTAL_PAT_PER_DIAGAANTAL_SUBTRAJECT_PER_DIAGAANTAL_PAT_PER_SPCAANTAL_SUBTRAJECT_PER_SPCGEMIDDELDE_VERKOOPPRIJS
3462031.02023-11-202023-11-012014-01-01303841990356051221116142170218456153840.0
3462041.02023-11-202023-11-012015-01-013622219900620152246349270900815971450.0
3462051.02023-11-202023-11-012020-01-0131307997900231111266210469612618563NaN
3462061.02023-11-202023-11-012014-01-013038561493990401191114217021845615220.0
3462071.02023-11-202023-11-012020-01-013137629790030092320318441046961261856322785.0
3462081.02023-11-202023-11-012020-01-013207019790012234452188393103095918310466655.0
3462091.02023-11-202023-11-012020-01-0131307897900231411332870104696126185634845.0
3462101.02023-11-202023-11-012014-01-013032221992990681176669519142170218456154640.0
3462111.02023-11-202023-11-012014-01-01303293131999214221313177714217021845615340.0
3462121.02023-11-202023-11-012014-01-0130328813199909911222271142170218456151940.0